﻿
--删除固定工资
CREATE proc [dbo].[proc_Employee_Allowance_Delete]
(
	@id int
)	
as
	Begin
		Declare @EAId uniqueidentifier
		Select @EAId=EA.EAId From Employee_Allowance EA Where EA.Id=@id
		
		delete from Employee_Allowance where id=@id
		delete from Employee_Allowance_Company where EAId = @EAId
	End

